CREATE TABLE [dbo].[MapHotelRoomCategories]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[HotelId] [int] NOT NULL,
[RoomCategoryId] [int] NOT NULL,
[PricePerHour] [decimal] (18, 2) NULL,
[Description] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PricePerDay] [decimal] (18, 2) NULL,
[MoneyUnitId] [int] NULL,
[Images] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SmallImages] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Normal] [decimal] (18, 2) NULL,
[Weekend] [decimal] (18, 2) NULL,
[Holiday] [decimal] (18, 2) NULL,
[NormalCompany] [decimal] (18, 2) NULL,
[WeekendCompany] [decimal] (18, 2) NULL,
[HolidayCompany] [decimal] (18, 2) NULL,
[HolidayDate] [nvarchar] (100) COLLATE Vietnamese_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MapHotelRoomCategories] ADD CONSTRAINT [PK__MapHotel__3214EC07FE8DB977] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
